var tableMetaSource=[
    {
        "tableName": "DW_PURCHASE_FACT",
        "tableComment": "采购事实表",
        "columnName": "XUNJIA_CODE",
        "columnComment": "寻源单",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_ENTRY",
        "tableComment": "仓库入库表",
        "columnName": "COMPANY_CODE",
        "columnComment": "公司编号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_SALES_RECEIPT",
        "tableComment": "销售回款事实表¶颗粒度：公司代码+客户编码+销售凭证",
        "columnName": "SN",
        "columnComment": "流水号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_ORDER",
        "tableComment": "销售订单表",
        "columnName": "CONTRACT_TYPE",
        "columnComment": "合同类型",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY_M_FIRST_LAST",
        "tableComment": "月初、月末库存¶颗粒度：公司代码+工厂编码+仓库编码+库存分类+产品编码+日期（天）",
        "columnName": "DATA_DATE",
        "columnComment": "数据日期",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_PAYMENT",
        "tableComment": "采购付款清单",
        "columnName": "PAYMENT_DATE",
        "columnComment": "日期",
        "columnType": "CHAR"
    },
    {
        "tableName": "DW_WAREHOUSE_OUT",
        "tableComment": "仓库出库",
        "columnName": "COMPANY_CODE",
        "columnComment": "公司代码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_PLAN",
        "tableComment": "销售计划",
        "columnName": "CODE",
        "columnComment": "单据编码",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_EXPENSE",
        "tableComment": "财务费用明细¶颗粒度：公司代码+过账日期（天）+会计科目编码",
        "columnName": "COMPANY_CODE",
        "columnComment": "公司代码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_FACT",
        "tableComment": "销售金额事实表",
        "columnName": "SALE_DATE",
        "columnComment": "日期",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_SUPPLIERS",
        "tableComment": "供应商维度表",
        "columnName": "SUPPLIER_CODE",
        "columnComment": "供应商编号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_COLLECT_PLAN",
        "tableComment": "销售回款计划",
        "columnName": "CODE",
        "columnComment": "单据编码",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_SALES_WAREHOUS",
        "tableComment": "销售出库表",
        "columnName": "SALES_ORDER_TYPE",
        "columnComment": "销售订单类型",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_INVENTORY_ORDER",
        "tableComment": "采购物料入库清单",
        "columnName": "PROD_CODE",
        "columnComment": "物料号",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_LAST_PROD_PRICE",
        "tableComment": "最新物料价格",
        "columnName": "PROD_CODE",
        "columnComment": "产品编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_PO_ENTRY",
        "tableComment": "采购入库费用表¶颗粒度：公司编号+过账日期（日）+会计科目",
        "columnName": "COMPANY_CODE",
        "columnComment": "公司编号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SOURCE_PRICE",
        "tableComment": "物料寻源价格表",
        "columnName": "VOUCHER_DATE",
        "columnComment": "日期",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY",
        "tableComment": "库存明细表",
        "columnName": "DATA_DATE",
        "columnComment": "数据日期",
        "columnType": "TIMESTAMP(6)"
    },
    {
        "tableName": "DW_HR_MROSTER",
        "tableComment": "人事花名册",
        "columnName": "序号",
        "columnComment": "",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_WORK_ORDER",
        "tableComment": "生产订单",
        "columnName": "COMPANY_CODE",
        "columnComment": "公司代码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ENTRY",
        "tableComment": "生产入库明细¶颗粒度：入库单号+入库单行号",
        "columnName": "COMPANY_CODE",
        "columnComment": "公司编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_FACT",
        "tableComment": "采购事实表",
        "columnName": "PR_ITEM_NO",
        "columnComment": "采购需求单ID",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_SALES_ORDER",
        "tableComment": "销售订单表",
        "columnName": "SALES_ORG",
        "columnComment": "销售组织",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_OUT",
        "tableComment": "仓库出库",
        "columnName": "PROD_CODE",
        "columnComment": "产品编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_ENTRY",
        "tableComment": "仓库入库表",
        "columnName": "PROD_CODE",
        "columnComment": "产品编号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY",
        "tableComment": "库存明细表",
        "columnName": "COMPANY_CODE",
        "columnComment": "公司代码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_LAST_PROD_PRICE",
        "tableComment": "最新物料价格",
        "columnName": "FACTORY_CODE",
        "columnComment": "工厂代码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_COLLECT_PLAN",
        "tableComment": "销售回款计划",
        "columnName": "APPLY",
        "columnComment": "申请人",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_WORK_ENTRY",
        "tableComment": "生产入库明细¶颗粒度：入库单号+入库单行号",
        "columnName": "COMPANY_NAME",
        "columnComment": "公司名称",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ORDER",
        "tableComment": "生产订单",
        "columnName": "WORK_NO",
        "columnComment": "生产订单号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SUPPLIERS",
        "tableComment": "供应商维度表",
        "columnName": "SUPPLIER_NAME",
        "columnComment": "供应商全称",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY_M_FIRST_LAST",
        "tableComment": "月初、月末库存¶颗粒度：公司代码+工厂编码+仓库编码+库存分类+产品编码+日期（天）",
        "columnName": "COMPANY_CODE",
        "columnComment": "公司代码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SOURCE_PRICE",
        "tableComment": "物料寻源价格表",
        "columnName": "MATERIAL_CODE",
        "columnComment": "物料",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_INVENTORY_ORDER",
        "tableComment": "采购物料入库清单",
        "columnName": "FACTORY_CODE",
        "columnComment": "工厂ID",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_PLAN",
        "tableComment": "销售计划",
        "columnName": "PROPOSER",
        "columnComment": "申请人",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_SALES_FACT",
        "tableComment": "销售金额事实表",
        "columnName": "SALES_ORG",
        "columnComment": "销售组织",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_WAREHOUS",
        "tableComment": "销售出库表",
        "columnName": "SALES_ORG",
        "columnComment": "销售组织",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_PO_ENTRY",
        "tableComment": "采购入库费用表¶颗粒度：公司编号+过账日期（日）+会计科目",
        "columnName": "FISAL_YEAR",
        "columnComment": "会计年度",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_HR_MROSTER",
        "tableComment": "人事花名册",
        "columnName": "档案号",
        "columnComment": "",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_EXPENSE",
        "tableComment": "财务费用明细¶颗粒度：公司代码+过账日期（天）+会计科目编码",
        "columnName": "FISAL_YEAR",
        "columnComment": "会计年度",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_PAYMENT",
        "tableComment": "采购付款清单",
        "columnName": "COMPANY_CODE",
        "columnComment": "公司编号",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_SALES_RECEIPT",
        "tableComment": "销售回款事实表¶颗粒度：公司代码+客户编码+销售凭证",
        "columnName": "SALE_VOUCHER",
        "columnComment": "销售凭证",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_PO_ENTRY",
        "tableComment": "采购入库费用表¶颗粒度：公司编号+过账日期（日）+会计科目",
        "columnName": "POSTING_DATE",
        "columnComment": "过账日期",
        "columnType": "TIMESTAMP(6)"
    },
    {
        "tableName": "DW_FINANCE_SALES_RECEIPT",
        "tableComment": "销售回款事实表¶颗粒度：公司代码+客户编码+销售凭证",
        "columnName": "COMPANY_CODE",
        "columnComment": "公司代码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY",
        "tableComment": "库存明细表",
        "columnName": "FACTORY_CODE",
        "columnComment": "工厂代码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_WAREHOUS",
        "tableComment": "销售出库表",
        "columnName": "DISTRIBUTION_CHANNEL",
        "columnComment": "分销渠道",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ORDER",
        "tableComment": "生产订单",
        "columnName": "WORK_DETAIL_NO",
        "columnComment": "生产订单行号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_LAST_PROD_PRICE",
        "tableComment": "最新物料价格",
        "columnName": "PRICE",
        "columnComment": "标准单价",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_SALES_FACT",
        "tableComment": "销售金额事实表",
        "columnName": "SHORTNAME",
        "columnComment": "公司简称",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_SOURCE_PRICE",
        "tableComment": "物料寻源价格表",
        "columnName": "TAX_PRICE",
        "columnComment": "成交价",
        "columnType": "BINARY_DOUBLE"
    },
    {
        "tableName": "DW_SALES_COLLECT_PLAN",
        "tableComment": "销售回款计划",
        "columnName": "APPLY_DEPT_CODE",
        "columnComment": "申请部门编码",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_WAREHOUSE_ENTRY",
        "tableComment": "仓库入库表",
        "columnName": "FACTORY_CODE",
        "columnComment": "工厂编号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_INVENTORY_ORDER",
        "tableComment": "采购物料入库清单",
        "columnName": "WAREHOUSE_DATE",
        "columnComment": "入库日期",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_HR_MROSTER",
        "tableComment": "人事花名册",
        "columnName": "姓名",
        "columnComment": "",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_OUT",
        "tableComment": "仓库出库",
        "columnName": "FACTORY_CODE",
        "columnComment": "工厂编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ENTRY",
        "tableComment": "生产入库明细¶颗粒度：入库单号+入库单行号",
        "columnName": "WORK_NO",
        "columnComment": "生产订单号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_EXPENSE",
        "tableComment": "财务费用明细¶颗粒度：公司代码+过账日期（天）+会计科目编码",
        "columnName": "POSTING_DATE",
        "columnComment": "过账日期",
        "columnType": "TIMESTAMP(6)"
    },
    {
        "tableName": "DW_SALES_ORDER",
        "tableComment": "销售订单表",
        "columnName": "DISTRIBUTION_CHANNEL",
        "columnComment": "分销渠道",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY_M_FIRST_LAST",
        "tableComment": "月初、月末库存¶颗粒度：公司代码+工厂编码+仓库编码+库存分类+产品编码+日期（天）",
        "columnName": "FACTORY_CODE",
        "columnComment": "工厂编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_PAYMENT",
        "tableComment": "采购付款清单",
        "columnName": "COMPANY_NAME",
        "columnComment": "公司名称",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_FACT",
        "tableComment": "采购事实表",
        "columnName": "SRM_ORDER_CODE",
        "columnComment": "SRM订单号",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_SALES_PLAN",
        "tableComment": "销售计划",
        "columnName": "APPLY_DEPT_CODE",
        "columnComment": "申请部门编码",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_SUPPLIERS",
        "tableComment": "供应商维度表",
        "columnName": "JOIN_TIME",
        "columnComment": "加入时间",
        "columnType": "TIMESTAMP(6)"
    },
    {
        "tableName": "DW_SUPPLIERS",
        "tableComment": "供应商维度表",
        "columnName": "EXIT_TIME",
        "columnComment": "退出时间",
        "columnType": "TIMESTAMP(6)"
    },
    {
        "tableName": "DW_WORK_ORDER",
        "tableComment": "生产订单",
        "columnName": "WORK_TYPE",
        "columnComment": "生产类型",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ENTRY",
        "tableComment": "生产入库明细¶颗粒度：入库单号+入库单行号",
        "columnName": "ENTRY_NO",
        "columnComment": "入库单号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_COLLECT_PLAN",
        "tableComment": "销售回款计划",
        "columnName": "APPLY_DATE",
        "columnComment": "申请日期",
        "columnType": "CHAR"
    },
    {
        "tableName": "DW_LAST_PROD_PRICE",
        "tableComment": "最新物料价格",
        "columnName": "MOV_AGE_PRICE",
        "columnComment": "移动平均价",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_INVENTORY",
        "tableComment": "库存明细表",
        "columnName": "WAREHOUSE_CODE",
        "columnComment": "仓库代码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_ENTRY",
        "tableComment": "仓库入库表",
        "columnName": "WAREHOUSE_CODE",
        "columnComment": "仓库编号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_OUT",
        "tableComment": "仓库出库",
        "columnName": "WAREHOUSE_CODE",
        "columnComment": "仓库编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_ORDER",
        "tableComment": "销售订单表",
        "columnName": "CONTRACT_NO",
        "columnComment": "合同号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_FACT",
        "tableComment": "采购事实表",
        "columnName": "ORDER_CODE",
        "columnComment": "采购订单号",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_SALES_RECEIPT",
        "tableComment": "销售回款事实表¶颗粒度：公司代码+客户编码+销售凭证",
        "columnName": "CUSTOMER_CODE",
        "columnComment": "客户编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_PAYMENT",
        "tableComment": "采购付款清单",
        "columnName": "SUPPLIER_CODE",
        "columnComment": "供应商编号",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_EXPENSE",
        "tableComment": "财务费用明细¶颗粒度：公司代码+过账日期（天）+会计科目编码",
        "columnName": "POSTING_MONTH",
        "columnComment": "过账日期所属月份",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_HR_MROSTER",
        "tableComment": "人事花名册",
        "columnName": "公司ID",
        "columnComment": "",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_FINANCE_PO_ENTRY",
        "tableComment": "采购入库费用表¶颗粒度：公司编号+过账日期（日）+会计科目",
        "columnName": "POSTING_MONTH",
        "columnComment": "过账月份",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_WAREHOUS",
        "tableComment": "销售出库表",
        "columnName": "PROD_TYPE",
        "columnComment": "产品组",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_FACT",
        "tableComment": "销售金额事实表",
        "columnName": "CUSTOMER",
        "columnComment": "客户",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_SALES_PLAN",
        "tableComment": "销售计划",
        "columnName": "APPLY_DATE",
        "columnComment": "申请日期",
        "columnType": "CHAR"
    },
    {
        "tableName": "DW_PURCHASE_INVENTORY_ORDER",
        "tableComment": "采购物料入库清单",
        "columnName": "QTY",
        "columnComment": "数量",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_SOURCE_PRICE",
        "tableComment": "物料寻源价格表",
        "columnName": "SOURCE_PRICE",
        "columnComment": "寻源价",
        "columnType": "BINARY_DOUBLE"
    },
    {
        "tableName": "DW_INVENTORY_M_FIRST_LAST",
        "tableComment": "月初、月末库存¶颗粒度：公司代码+工厂编码+仓库编码+库存分类+产品编码+日期（天）",
        "columnName": "WAREHOUSE_CODE",
        "columnComment": "仓库编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ORDER",
        "tableComment": "生产订单",
        "columnName": "WORK_ADMIN",
        "columnComment": "生产管理员",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ENTRY",
        "tableComment": "生产入库明细¶颗粒度：入库单号+入库单行号",
        "columnName": "ENTRY_DETAIL_NO",
        "columnComment": "入库单行号（明细行号）",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_COLLECT_PLAN",
        "tableComment": "销售回款计划",
        "columnName": "APPLY_COMPANY_CODE",
        "columnComment": "申请公司代码",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_LAST_PROD_PRICE",
        "tableComment": "最新物料价格",
        "columnName": "YEAR",
        "columnComment": "年",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY",
        "tableComment": "库存明细表",
        "columnName": "PROD_CODE",
        "columnComment": "产品编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_ENTRY",
        "tableComment": "仓库入库表",
        "columnName": "DATETIME",
        "columnComment": "入库时间",
        "columnType": "TIMESTAMP(6)"
    },
    {
        "tableName": "DW_WAREHOUSE_OUT",
        "tableComment": "仓库出库",
        "columnName": "DATETIME",
        "columnComment": "出入库日期",
        "columnType": "TIMESTAMP(6)"
    },
    {
        "tableName": "DW_SALES_ORDER",
        "tableComment": "销售订单表",
        "columnName": "CONTRACT_DETAIL_NO",
        "columnComment": "合同行号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_FACT",
        "tableComment": "采购事实表",
        "columnName": "COMPANY_CODE",
        "columnComment": "公司编号",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_SALES_RECEIPT",
        "tableComment": "销售回款事实表¶颗粒度：公司代码+客户编码+销售凭证",
        "columnName": "RECEIPT_DATE",
        "columnComment": "回款日期",
        "columnType": "TIMESTAMP(6)"
    },
    {
        "tableName": "DW_PURCHASE_PAYMENT",
        "tableComment": "采购付款清单",
        "columnName": "SUPPLIER_NAME",
        "columnComment": "供应商名称",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_EXPENSE",
        "tableComment": "财务费用明细¶颗粒度：公司代码+过账日期（天）+会计科目编码",
        "columnName": "POSTING_YEAR",
        "columnComment": "过账日期所属年份",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_HR_MROSTER",
        "tableComment": "人事花名册",
        "columnName": "公司",
        "columnComment": "",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_PO_ENTRY",
        "tableComment": "采购入库费用表¶颗粒度：公司编号+过账日期（日）+会计科目",
        "columnName": "POSTING_YEAR",
        "columnComment": "过账年份",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_WAREHOUS",
        "tableComment": "销售出库表",
        "columnName": "SALE_ORDER_NO",
        "columnComment": "销售订单号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_FACT",
        "tableComment": "销售金额事实表",
        "columnName": "SALESMAN",
        "columnComment": "业务员",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_SALES_PLAN",
        "tableComment": "销售计划",
        "columnName": "APPLY_COMPANY_CODE",
        "columnComment": "申请公司代码",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_PURCHASE_INVENTORY_ORDER",
        "tableComment": "采购物料入库清单",
        "columnName": "UNIT",
        "columnComment": "单位",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY_M_FIRST_LAST",
        "tableComment": "月初、月末库存¶颗粒度：公司代码+工厂编码+仓库编码+库存分类+产品编码+日期（天）",
        "columnName": "PROD_CODE",
        "columnComment": "产品编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ORDER",
        "tableComment": "生产订单",
        "columnName": "PROD_CODE",
        "columnComment": "产品编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ENTRY",
        "tableComment": "生产入库明细¶颗粒度：入库单号+入库单行号",
        "columnName": "PROD_CODE",
        "columnComment": "物料编码（产品编码）",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_COLLECT_PLAN",
        "tableComment": "销售回款计划",
        "columnName": "MAKE_COMPANY_CODE",
        "columnComment": "制单公司编码",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_LAST_PROD_PRICE",
        "tableComment": "最新物料价格",
        "columnName": "MONTH",
        "columnComment": "月",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY",
        "tableComment": "库存明细表",
        "columnName": "QTY",
        "columnComment": "数量",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_WAREHOUSE_ENTRY",
        "tableComment": "仓库入库表",
        "columnName": "QTY",
        "columnComment": "数量",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_WAREHOUSE_OUT",
        "tableComment": "仓库出库",
        "columnName": "QTY",
        "columnComment": "数量",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_SALES_ORDER",
        "tableComment": "销售订单表",
        "columnName": "PROD_TYPE",
        "columnComment": "产品组",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_FACT",
        "tableComment": "采购事实表",
        "columnName": "COMPANY_NAME",
        "columnComment": "公司名称",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_SALES_RECEIPT",
        "tableComment": "销售回款事实表¶颗粒度：公司代码+客户编码+销售凭证",
        "columnName": "CLAIM_AMOUNT",
        "columnComment": "认领金额",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_PURCHASE_PAYMENT",
        "tableComment": "采购付款清单",
        "columnName": "AMOUNT",
        "columnComment": "付款金额",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_FINANCE_EXPENSE",
        "tableComment": "财务费用明细¶颗粒度：公司代码+过账日期（天）+会计科目编码",
        "columnName": "ACCOUNT_TITLE_CODE",
        "columnComment": "会计科目编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_HR_MROSTER",
        "tableComment": "人事花名册",
        "columnName": "公司简称",
        "columnComment": "",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_PO_ENTRY",
        "tableComment": "采购入库费用表¶颗粒度：公司编号+过账日期（日）+会计科目",
        "columnName": "ACCOUNT_TITLE_CODE",
        "columnComment": "会计科目",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_WAREHOUS",
        "tableComment": "销售出库表",
        "columnName": "CUSTOMER",
        "columnComment": "客户",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_FACT",
        "tableComment": "销售金额事实表",
        "columnName": "PROD_TYPE",
        "columnComment": "产品组编号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_PLAN",
        "tableComment": "销售计划",
        "columnName": "MAKE_COMPANY_CODE",
        "columnComment": "制单公司代码",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_INVENTORY_ORDER",
        "tableComment": "采购物料入库清单",
        "columnName": "ORDER_NO",
        "columnComment": "采购订单号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY_M_FIRST_LAST",
        "tableComment": "月初、月末库存¶颗粒度：公司代码+工厂编码+仓库编码+库存分类+产品编码+日期（天）",
        "columnName": "QTY",
        "columnComment": "数量",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_WORK_ORDER",
        "tableComment": "生产订单",
        "columnName": "PROD_DESC",
        "columnComment": "产品编码描述",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ENTRY",
        "tableComment": "生产入库明细¶颗粒度：入库单号+入库单行号",
        "columnName": "PROD_DESC",
        "columnComment": "物料描述（产品描述）",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_COLLECT_PLAN",
        "tableComment": "销售回款计划",
        "columnName": "YEAR_MONTH",
        "columnComment": "月份",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY",
        "tableComment": "库存明细表",
        "columnName": "PROD_TYPE",
        "columnComment": "产品类型",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_ENTRY",
        "tableComment": "仓库入库表",
        "columnName": "UOM",
        "columnComment": "计量单位",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_OUT",
        "tableComment": "仓库出库",
        "columnName": "UOM",
        "columnComment": "计量单位",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_ORDER",
        "tableComment": "销售订单表",
        "columnName": "PROD_CODE",
        "columnComment": "物料编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_FACT",
        "tableComment": "采购事实表",
        "columnName": "SUPPLIER_CODE",
        "columnComment": "供应商编号",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_EXPENSE",
        "tableComment": "财务费用明细¶颗粒度：公司代码+过账日期（天）+会计科目编码",
        "columnName": "ACCOUNT_TITLE_NAME",
        "columnComment": "会计科目名称",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_HR_MROSTER",
        "tableComment": "人事花名册",
        "columnName": "部门ID",
        "columnComment": "",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_FINANCE_PO_ENTRY",
        "tableComment": "采购入库费用表¶颗粒度：公司编号+过账日期（日）+会计科目",
        "columnName": "ACCOUNT_TITLE_NAME",
        "columnComment": "会计科目名称",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_WAREHOUS",
        "tableComment": "销售出库表",
        "columnName": "SALE_ORDER_DETAIL_NO",
        "columnComment": "行项目号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_FACT",
        "tableComment": "销售金额事实表",
        "columnName": "PROD_TYPE_NAME",
        "columnComment": "产品组名称",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_PLAN",
        "tableComment": "销售计划",
        "columnName": "YEAR_MONTH",
        "columnComment": "年月",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY_M_FIRST_LAST",
        "tableComment": "月初、月末库存¶颗粒度：公司代码+工厂编码+仓库编码+库存分类+产品编码+日期（天）",
        "columnName": "PROD_TYPE",
        "columnComment": "产品类型",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ORDER",
        "tableComment": "生产订单",
        "columnName": "WORK_QTY",
        "columnComment": "生产数量",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_WORK_ENTRY",
        "tableComment": "生产入库明细¶颗粒度：入库单号+入库单行号",
        "columnName": "ENTRY_TIME",
        "columnComment": "入库日期",
        "columnType": "TIMESTAMP(6)"
    },
    {
        "tableName": "DW_SALES_COLLECT_PLAN",
        "tableComment": "销售回款计划",
        "columnName": "APPENDIX",
        "columnComment": "附件",
        "columnType": "CLOB"
    },
    {
        "tableName": "DW_INVENTORY",
        "tableComment": "库存明细表",
        "columnName": "UOM",
        "columnComment": "计量单位",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_ENTRY",
        "tableComment": "仓库入库表",
        "columnName": "PO_NO",
        "columnComment": "采购订单号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_OUT",
        "tableComment": "仓库出库",
        "columnName": "PO_NO",
        "columnComment": "采购订单号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_ORDER",
        "tableComment": "销售订单表",
        "columnName": "PROD_DESC",
        "columnComment": "物料描述",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_FACT",
        "tableComment": "采购事实表",
        "columnName": "SUPPLIER_NAME",
        "columnComment": "供应商名称",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_EXPENSE",
        "tableComment": "财务费用明细¶颗粒度：公司代码+过账日期（天）+会计科目编码",
        "columnName": "AMOUNT",
        "columnComment": "金额",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_HR_MROSTER",
        "tableComment": "人事花名册",
        "columnName": "部门",
        "columnComment": "",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_PO_ENTRY",
        "tableComment": "采购入库费用表¶颗粒度：公司编号+过账日期（日）+会计科目",
        "columnName": "AMOUNT",
        "columnComment": "入库金额",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_SALES_WAREHOUS",
        "tableComment": "销售出库表",
        "columnName": "DELIVERY_NOTICE_NO",
        "columnComment": "发货通知单号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_FACT",
        "tableComment": "销售金额事实表",
        "columnName": "PROD_CODE",
        "columnComment": "物料号",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_SALES_PLAN",
        "tableComment": "销售计划",
        "columnName": "APPENDIX",
        "columnComment": "附件",
        "columnType": "CLOB"
    },
    {
        "tableName": "DW_INVENTORY_M_FIRST_LAST",
        "tableComment": "月初、月末库存¶颗粒度：公司代码+工厂编码+仓库编码+库存分类+产品编码+日期（天）",
        "columnName": "UOM",
        "columnComment": "计量单位",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ORDER",
        "tableComment": "生产订单",
        "columnName": "WORK_START_TIME",
        "columnComment": "生产开始时间",
        "columnType": "TIMESTAMP(6)"
    },
    {
        "tableName": "DW_WORK_ENTRY",
        "tableComment": "生产入库明细¶颗粒度：入库单号+入库单行号",
        "columnName": "ENTRY_QTY",
        "columnComment": "入库实物量",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_SALES_COLLECT_PLAN",
        "tableComment": "销售回款计划",
        "columnName": "REMARK",
        "columnComment": "备注",
        "columnType": "CLOB"
    },
    {
        "tableName": "DW_INVENTORY",
        "tableComment": "库存明细表",
        "columnName": "PRICE",
        "columnComment": "单价",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_WAREHOUSE_ENTRY",
        "tableComment": "仓库入库表",
        "columnName": "WORK_NO",
        "columnComment": "工单号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_OUT",
        "tableComment": "仓库出库",
        "columnName": "WORK_NO",
        "columnComment": "生产订单号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_ORDER",
        "tableComment": "销售订单表",
        "columnName": "CONTRACT_START_DATE",
        "columnComment": "合同起始日期",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_FACT",
        "tableComment": "采购事实表",
        "columnName": "PURCHASE_ORG",
        "columnComment": "采购组织",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_EXPENSE",
        "tableComment": "财务费用明细¶颗粒度：公司代码+过账日期（天）+会计科目编码",
        "columnName": "FUNC_SCOPE",
        "columnComment": "功能范围",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_HR_MROSTER",
        "tableComment": "人事花名册",
        "columnName": "职务",
        "columnComment": "",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_PO_ENTRY",
        "tableComment": "采购入库费用表¶颗粒度：公司编号+过账日期（日）+会计科目",
        "columnName": "FUNC_SCOPE",
        "columnComment": "功能范围",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_WAREHOUS",
        "tableComment": "销售出库表",
        "columnName": "PROD_CODE",
        "columnComment": "物料编码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_FACT",
        "tableComment": "销售金额事实表",
        "columnName": "PROD_DESC",
        "columnComment": "物料描述",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_PLAN",
        "tableComment": "销售计划",
        "columnName": "REMARKS",
        "columnComment": "备注",
        "columnType": "CLOB"
    },
    {
        "tableName": "DW_INVENTORY_M_FIRST_LAST",
        "tableComment": "月初、月末库存¶颗粒度：公司代码+工厂编码+仓库编码+库存分类+产品编码+日期（天）",
        "columnName": "PRICE",
        "columnComment": "单价",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_WORK_ORDER",
        "tableComment": "生产订单",
        "columnName": "SALE_ORDER_NO",
        "columnComment": "销售订单号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ENTRY",
        "tableComment": "生产入库明细¶颗粒度：入库单号+入库单行号",
        "columnName": "ENTRY_DISCOUNT_100_QTY",
        "columnComment": "折百数量",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_SALES_COLLECT_PLAN",
        "tableComment": "销售回款计划",
        "columnName": "SALES_MAN",
        "columnComment": "销售员",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_INVENTORY",
        "tableComment": "库存明细表",
        "columnName": "CATEGORY",
        "columnComment": "库存分类",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_ENTRY",
        "tableComment": "仓库入库表",
        "columnName": "MOVE_TYPE",
        "columnComment": "移动类型",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_OUT",
        "tableComment": "仓库出库",
        "columnName": "MOVE_TYPE",
        "columnComment": "移动类型",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_ORDER",
        "tableComment": "销售订单表",
        "columnName": "CONTRACT_END_DATE",
        "columnComment": "合同结束日期",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_PURCHASE_FACT",
        "tableComment": "采购事实表",
        "columnName": "PAYMENT_METHOD",
        "columnComment": "付款方式",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_EXPENSE",
        "tableComment": "财务费用明细¶颗粒度：公司代码+过账日期（天）+会计科目编码",
        "columnName": "VOCHER_TYPE",
        "columnComment": "凭证类型",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_HR_MROSTER",
        "tableComment": "人事花名册",
        "columnName": "职级",
        "columnComment": "",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_PO_ENTRY",
        "tableComment": "采购入库费用表¶颗粒度：公司编号+过账日期（日）+会计科目",
        "columnName": "VOCHER_TYPE",
        "columnComment": "凭证类型",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_WAREHOUS",
        "tableComment": "销售出库表",
        "columnName": "PROD_DESC",
        "columnComment": "物料描述",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_FACT",
        "tableComment": "销售金额事实表",
        "columnName": "ORDER_NUM",
        "columnComment": "数量",
        "columnType": "BINARY_DOUBLE"
    },
    {
        "tableName": "DW_SALES_PLAN",
        "tableComment": "销售计划",
        "columnName": "PROD_CODE",
        "columnComment": "产品编码",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_INVENTORY_M_FIRST_LAST",
        "tableComment": "月初、月末库存¶颗粒度：公司代码+工厂编码+仓库编码+库存分类+产品编码+日期（天）",
        "columnName": "CATEGORY",
        "columnComment": "库存分类",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ORDER",
        "tableComment": "生产订单",
        "columnName": "SALE_ORDER_DETAIL_NO",
        "columnComment": "销售订单行号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WORK_ENTRY",
        "tableComment": "生产入库明细¶颗粒度：入库单号+入库单行号",
        "columnName": "ENTRY_UOM",
        "columnComment": "基本计量单位",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_COLLECT_PLAN",
        "tableComment": "销售回款计划",
        "columnName": "CUSTOM_CODE",
        "columnComment": "客户编码",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_ENTRY",
        "tableComment": "仓库入库表",
        "columnName": "MARK",
        "columnComment": "借贷标识",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_OUT",
        "tableComment": "仓库出库",
        "columnName": "MARK",
        "columnComment": "出入库标记",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_ORDER",
        "tableComment": "销售订单表",
        "columnName": "CONTRACT_NUM",
        "columnComment": "合同数量",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_PURCHASE_FACT",
        "tableComment": "采购事实表",
        "columnName": "MATERIAL_CODE",
        "columnComment": "物料号",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_EXPENSE",
        "tableComment": "财务费用明细¶颗粒度：公司代码+过账日期（天）+会计科目编码",
        "columnName": "RSTGR",
        "columnComment": "原因代码",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_HR_MROSTER",
        "tableComment": "人事花名册",
        "columnName": "现任岗位",
        "columnComment": "",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_FINANCE_PO_ENTRY",
        "tableComment": "采购入库费用表¶颗粒度：公司编号+过账日期（日）+会计科目",
        "columnName": "SUPPLIER_CODE",
        "columnComment": "供应商编号",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_WAREHOUS",
        "tableComment": "销售出库表",
        "columnName": "DELIVERY_FACTORY",
        "columnComment": "发货工厂",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_FACT",
        "tableComment": "销售金额事实表",
        "columnName": "AMOUNT",
        "columnComment": "金额",
        "columnType": "BINARY_DOUBLE"
    },
    {
        "tableName": "DW_SALES_PLAN",
        "tableComment": "销售计划",
        "columnName": "PROD_DESC",
        "columnComment": "产品描述",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_WORK_ENTRY",
        "tableComment": "生产入库明细¶颗粒度：入库单号+入库单行号",
        "columnName": "WORK_TOTAL_QTY",
        "columnComment": "总订单数量",
        "columnType": "NUMBER"
    },
    {
        "tableName": "DW_SALES_COLLECT_PLAN",
        "tableComment": "销售回款计划",
        "columnName": "COLLECT_TYPE_CODE",
        "columnComment": "回款类型编码",
        "columnType": "VARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_ENTRY",
        "tableComment": "仓库入库表",
        "columnName": "DOC_TYPE",
        "columnComment": "凭证类型",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_WAREHOUSE_OUT",
        "tableComment": "仓库出库",
        "columnName": "DOC_TYPE",
        "columnComment": "单据类型",
        "columnType": "NVARCHAR2"
    },
    {
        "tableName": "DW_SALES_ORDER",
        "tableComment": "销售订单表",
        "columnName": "CONTRACT_UNIT_PRICE",
        "columnComment": "合同含税单价",
        "columnType": "NUMBER"
    }
]